package com.linktel.productionLine.EasyExcel.monthPlanning.model;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.linktel.productionLine.EasyExcel.ExcelNotation;
import lombok.Data;

/**
 * 下载excel，定义的日出勤数据对象
 *
 */
@Data
public class WriteMonthlyPlanning {
    @ExcelIgnore //忽略改属性
    private Long id;
    /**
     * 产线编码
     */
    @ExcelProperty(value = "产线编码",index = 0)
    @ColumnWidth(12)
    @ExcelNotation(value = "产线编码（必须在已有的产线名单中，并且必须定义了该产线的月度产能规划），例如：F1/F2",remarkColumnWide =(short)  2, remarkRowHigh = 5)
    private String productionLineCode;
    /**
     * 产线名称
     */
    @ExcelProperty(value = "产线名称",index = 1)
    @ColumnWidth(20)
    @ExcelNotation(value = "产线名称（必须在已有的产线名单中）",remarkColumnWide =(short) 2, remarkRowHigh = 2)
    private String productionLineName;
    /**
     * 年
     */
    @ColumnWidth(12)
    @ExcelNotation(value = "一个整数，例如：2023",remarkColumnWide =(short)  2, remarkRowHigh = 2)
    @ExcelProperty(value = "年",index = 2)
    private String year;
    /**
     * 月
     */
    @ColumnWidth(12)
    @ExcelNotation(value = "一个大于0，小于等于12的整数，例如：6",remarkColumnWide =(short)  2, remarkRowHigh = 2)
    @ExcelProperty(value = "月",index = 3)
    private String month;
    /**
     * 产线规划人数
     */
    @ColumnWidth(12)
    @ExcelNotation(value = "一个整数，例如：9",remarkColumnWide =(short)  2, remarkRowHigh = 2)
    @ExcelProperty(value = "产线规划人数",index = 4)
    private Integer planningNumber;
    /**
     * 关键工序编码
     */
    @ExcelProperty(value = "关键工序编码",index = 5)
    @ColumnWidth(12)
    @ExcelNotation(value = "关键工序编码（必须在已有的工序名单中，并且必须定义了该关键工序编码的月度产能规划，注意空格），例如：管号对应 SN matching",remarkColumnWide =(short) 3, remarkRowHigh = 4)
    private String keyStepCode;
    /**
     * 关键工序名称
     */
    @ExcelProperty(value = "关键工序名称",index = 6)
    @ColumnWidth(24)
    @ExcelNotation(value = "关键工序名称（必须在已有的工序名单中）",remarkColumnWide =(short) 2, remarkRowHigh = 2)
    private String keyStepName;
    /**
     * 月产能规划
     */
    @ColumnWidth(12)
    @ExcelNotation(value = "一个整数，例如：1200",remarkColumnWide =(short)  2, remarkRowHigh = 5)
    @ExcelProperty(value = "月产能规划",index = 7)
    private Integer planningCapacity;
    /**
     * 排序字段
     */
    @ColumnWidth(12)
    @ExcelNotation(value = "一个整数，数越小，优先级越高",remarkColumnWide =(short)  2, remarkRowHigh = 5)
    @ExcelProperty(value = "排序字段",index = 8)
    private Integer sort;
}